package BaseDatos;

/**
 * @author Angel Lopez
 */
public interface QueriesMySQL {
    
    
    public static final String INSERT_GAME = "INSERT INTO GAME (ID_OWNER, DATE_START, DATE_FINISH) VALUES (?, NOW(),NOW())";
    public static final String SELECT_GAME_LAST_INSERT = "SELECT DISTINCT LAST_INSERT_ID() FROM GAME";
    public static final String UPDATE_GAME_DATE_FINISH = "UPDATE GAME SET DATE_FINISH= NOW() WHERE(ID = ?)";
    public static final String SELECT_GAMES = "SELECT * FROM GAME ORDER BY ID_GAME";
    
}
